/*
 Navicat Premium Data Transfer

 Source Server         : localmysql
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost
 Source Database       : bshop

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 08/14/2017 15:30:46 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `shop_category`
-- ----------------------------
DROP TABLE IF EXISTS `shop_category`;
CREATE TABLE `shop_category` (
  `cateId` int(11) NOT NULL,
  `cateName` varchar(20) DEFAULT NULL,
  `superId` int(11) DEFAULT NULL,
  `isSuper` int(11) DEFAULT NULL,
  `sortId` int(30) DEFAULT NULL,
  PRIMARY KEY (`cateId`),
  KEY `superId` (`superId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_category`
-- ----------------------------
BEGIN;
INSERT INTO `shop_category` VALUES ('10', '电脑办公', null, '1', null), ('11', '手机数码', null, '1', null), ('12', '运动户外', null, '1', null), ('13', '家用电器', null, '1', null), ('14', '玩具乐器', null, '1', null), ('15', '食品零食', null, '1', null), ('16', '游戏', null, '1', null), ('1010', '电脑整机', '10', '0', null), ('1011', '电脑配件', '10', '0', null), ('1012', '外设', '10', '0', null), ('1501', '零食', '15', '0', null), ('1610', '手游', '16', '0', null), ('1611', '端游', '16', '0', null), ('101010', '笔记本', '1010', '0', null), ('101011', '台式机', '1010', '0', null), ('101012', '平板电脑', '1010', '0', null), ('101013', '一体机', '1010', '0', null), ('101110', '显示器', '1011', '0', null), ('101111', '硬盘', '1011', '0', null), ('101112', '内存', '1011', '0', null), ('101113', '主板', '1011', '0', null), ('101114', '电源', '1011', '0', null), ('101210', '键盘', '1012', '0', null), ('101211', '鼠标', '1012', '0', null), ('101212', '耳机', '1012', '0', null), ('101213', '摄像头', '1012', '0', null), ('161010', '休闲', '1610', '0', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
